package com.example.boot3.mapper;

import com.example.boot3.model.User;
import com.example.boot3.model.Vehicle;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;
import java.util.Map;

/**
 * @author 邹成明
 */
@Mapper
public interface VehicleMapper {
    List<Vehicle> getVehiclesInfoList();
    List<Map<String,String>> getVehicleCountByFleet();
    List<Map<String,String>> getVehicleCountByType();
    List<Map<String,String>> getVehicleCountByStatus();
    List<Map<String,String>> getVehicleUseTimesList();
    List<Map<String,String>> getVehiclesMiles();
    Integer addVehicle(Vehicle vehicle);
    List<Map<String,String>> getVehicleCostList();
    Integer updateVehicleStatus(String vehicle_id,String new_status);
    String getVehicleStatus(String vehicle_id);

    Integer deleteVehicle(String vehicle_id);




}
